/*
 * Tencent is pleased to support the open source community by making BK-CI 蓝鲸持续集成平台 available.
 *
 * Copyright (C) 2019 THL A29 Limited, a Tencent company.  All rights reserved.
 *
 * BK-CI 蓝鲸持续集成平台 is licensed under the MIT license.
 *
 * A copy of the MIT License is included in this file.
 *
 *
 * Terms of the MIT License:
 * ---------------------------------------------------
 * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
 * documentation files (the "Software"), to deal in the Software without restriction, including without limitation the
 * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to
 * permit persons to whom the Software is furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all copies or substantial portions of
 * the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT
 * LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN
 * NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
 * WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE
 * SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 */

package com.tencent.devops.store.common.dao

import com.tencent.devops.common.api.util.UUIDUtil
import com.tencent.devops.model.store.tables.TStoreBase
import com.tencent.devops.model.store.tables.TStoreVersionLog
import com.tencent.devops.model.store.tables.records.TStoreVersionLogRecord
import com.tencent.devops.store.pojo.common.enums.ReleaseTypeEnum
import org.jooq.DSLContext
import org.jooq.Result
import org.springframework.stereotype.Repository
import java.time.LocalDateTime

@Repository
class StoreVersionLogDao {

    fun saveStoreVersion(
        dslContext: DSLContext,
        userId: String,
        storeId: String,
        releaseType: ReleaseTypeEnum,
        versionContent: String
    ) {
        with(TStoreVersionLog.T_STORE_VERSION_LOG) {
            dslContext.insertInto(
                this,
                ID,
                STORE_ID,
                RELEASE_TYPE,
                CONTENT,
                CREATOR,
                MODIFIER
            )
                .values(
                    UUIDUtil.generate(),
                    storeId,
                    releaseType.releaseType.toByte(),
                    versionContent,
                    userId,
                    userId
                )
                .onDuplicateKeyUpdate()
                .set(RELEASE_TYPE, releaseType.releaseType.toByte())
                .set(CONTENT, versionContent)
                .set(MODIFIER, userId)
                .set(UPDATE_TIME, LocalDateTime.now())
                .execute()
        }
    }

    fun getStoreVersion(dslContext: DSLContext, storeId: String): TStoreVersionLogRecord? {
        with(TStoreVersionLog.T_STORE_VERSION_LOG) {
            return dslContext.selectFrom(this)
                .where(STORE_ID.eq(storeId))
                .fetchOne()
        }
    }

    fun getStoreVersions(
        dslContext: DSLContext,
        storeIds: List<String>,
        getTestVersionFlag: Boolean = false
    ): Result<TStoreVersionLogRecord>? {
        with(TStoreVersionLog.T_STORE_VERSION_LOG) {
            var step = dslContext.selectFrom(this)
                .where(STORE_ID.`in`(storeIds))
            if (!getTestVersionFlag) {
                step = step.and(RELEASE_TYPE.notEqual(ReleaseTypeEnum.BRANCH_TEST.releaseType.toByte()))
            }
            return step.fetch()
        }
    }

    fun deleteByStoreCode(
        dslContext: DSLContext,
        storeCode: String,
        storeType: Byte
    ) {
        val tsb = TStoreBase.T_STORE_BASE
        val storeIds = dslContext.select(tsb.ID).from(tsb)
            .where(tsb.STORE_CODE.eq(storeCode).and(tsb.STORE_TYPE.eq(storeType))).fetch()
        with(TStoreVersionLog.T_STORE_VERSION_LOG) {
            dslContext.deleteFrom(this)
                .where(STORE_ID.`in`(storeIds))
                .execute()
        }
    }
}
